﻿<%@ Page Title="" Language="C#" MasterPageFile="~/Adminyemian/Admin.Master" AutoEventWireup="true" CodeBehind="adminxinxichaxun.aspx.cs" Inherits="zlh.Adminyemian.adminxinxichaxun" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
    <p>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
    <asp:Label ID="Label1" runat="server" CssClass="word" Text="学号："></asp:Label>
    <asp:TextBox ID="TextBox1" runat="server" CssClass="textbox"></asp:TextBox>
    &nbsp;&nbsp;<asp:Button ID="Button2" runat="server" CssClass="button" Text="查询" />
    &nbsp;
    </p>
<p>
&nbsp;&nbsp;&nbsp;
    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="stuNo" DataSourceID="SqlDataSource1" HorizontalAlign="Center" Width="719px">
        <Columns>
            <asp:BoundField DataField="stuNo" HeaderText="stuNo" ReadOnly="True" SortExpression="stuNo"></asp:BoundField>
            <asp:BoundField DataField="stuName" HeaderText="stuName" SortExpression="stuName"></asp:BoundField>
            <asp:BoundField DataField="Gender" HeaderText="Gender" SortExpression="Gender"></asp:BoundField>
            <asp:BoundField DataField="Age" HeaderText="Age" SortExpression="Age"></asp:BoundField>
            <asp:BoundField DataField="College" HeaderText="College" SortExpression="College"></asp:BoundField>
            <asp:BoundField DataField="Major" HeaderText="Major" SortExpression="Major"></asp:BoundField>
            <asp:BoundField DataField="Class" HeaderText="Class" SortExpression="Class"></asp:BoundField>
            <asp:BoundField DataField="Memo" HeaderText="Memo" SortExpression="Memo"></asp:BoundField>
            <asp:BoundField DataField="Address" HeaderText="Address" SortExpression="Address"></asp:BoundField>
        </Columns>
        <HeaderStyle CssClass="gridxiewHeaderstyle" />
        <RowStyle CssClass="gridviewrowstyle" />
    </asp:GridView>
</p>
<p>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:dhd2014112130ConnectionString2 %>" SelectCommand="SELECT * FROM [StudentInformation] WHERE ([stuNo] = @stuNo)">
        <SelectParameters>
            <asp:ControlParameter ControlID="TextBox1" Name="stuNo" PropertyName="Text" Type="String" />
        </SelectParameters>
    </asp:SqlDataSource>
    &nbsp;&nbsp;&nbsp;
    </p>
<p>
    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
    &nbsp;</p>
<p>
    &nbsp;</p>
<p>
    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
    &nbsp;&nbsp; &nbsp;<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:dhd2014112130ConnectionString2 %>" SelectCommand="SELECT * FROM [StudentInformation]">
    </asp:SqlDataSource>
</p>
<p>
    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;</p>
<asp:GridView ID="GridView2" runat="server" AllowPaging="True" AutoGenerateColumns="False" DataKeyNames="stuNo" DataSourceID="SqlDataSource2" Width="1066px">
    <Columns>
        <asp:BoundField DataField="stuNo" HeaderText="学号" ReadOnly="True" SortExpression="stuNo" />
        <asp:BoundField DataField="stuName" HeaderText="姓名" SortExpression="stuName" />
        <asp:BoundField DataField="Gender" HeaderText="性别" SortExpression="Gender" />
        <asp:BoundField DataField="Age" HeaderText="年龄" SortExpression="Age" />
        <asp:BoundField DataField="College" HeaderText="学院" SortExpression="College" />
        <asp:BoundField DataField="Major" HeaderText="专业" SortExpression="Major" />
        <asp:BoundField DataField="Class" HeaderText="班级" SortExpression="Class" />
        <asp:BoundField DataField="Memo" HeaderText="备注" SortExpression="Memo" />
        <asp:BoundField DataField="Address" HeaderText="地址" SortExpression="Address" />
    </Columns>
    <HeaderStyle CssClass="gridxiewHeaderstyle" />
    <RowStyle CssClass="gridviewrowstyle" />
</asp:GridView>
<p>
    <br />
</p>
</asp:Content>
